﻿<!DOCTYPE html>
<html>
	<head>
		<title>Introducing the Spreadsheet Editor user interface</title>
		<meta charset="utf-8" />
        <meta name="description" content="Introducing the Spreadsheet Editor user interface" />
		<link type="text/css" rel="stylesheet" href="../../../../../../common/main/resources/help/editor.css" />
		<link type = "text/css" rel = "stylesheet" href = "../../images/sprite.css" />
        <script type="text/javascript" src="../callback.js"></script>
        <script type="text/javascript" src="../search/js/page-search.js"></script>
	</head>
	<body>
		<div class="mainpart">
        <div class="search-field">
            <input id="search" class="searchBar" placeholder="Search" type="text" onkeypress="doSearch(event)">
        </div>
			<h1>Introducing the Spreadsheet Editor user interface</h1>
			<p>The <a href="https://www.onlyoffice.com/spreadsheet-editor.aspx" target="_blank" onclick="onhyperlinkclick(this)"><b>Spreadsheet Editor</b></a> uses a tabbed interface where editing commands are grouped into tabs by functionality.</p>
            <div class="onlineDocumentFeatures">
                <p>Main window of the Online Spreadsheet Editor:</p>
                <p><img alt="Online Spreadsheet Editor window" src="../images/interface/editorwindow.png" /></p>
            </div>
            <div class="desktopDocumentFeatures">
                <p>Main window of the Desktop Spreadsheet Editor:</p>
                <p><img alt="Desktop Spreadsheet Editor window" src="../images/interface/desktop_editorwindow.png" /></p>
            </div>
            <p>The editor interface consists of the following main elements:</p>
            <ol>
                <li>
                    The <b>Editor header</b> displays the logo, <span class="desktopDocumentFeatures"> tabs for all opened spreadsheets, </span> with their names and menu tabs..
                    <p>On the left side of the <b>Editor header</b> there are the <b>Save</b>, <b>Print file</b>, <b>Undo</b> and <b>Redo</b> buttons are located.</p>
                    <p><img alt="Icons in the editor header" src="../images/interface/leftpart.png" /></p>
                    <p>On the right side of the <b>Editor header</b> along with the user name the following icons are displayed:</p>
                    <ul>
                        <li><div class="icon icon-gotodocuments"></div> <b>Open file location</b> - <span class="desktopDocumentFeatures">in the <em>desktop version</em>, it allows opening the folder, where the file is stored, in the <b>File explorer</b> window.</span> <span class="onlineDocumentFeatures"> In the <em>online version</em>, it allows opening the folder in the <b>Documents</b> module where the file is stored, in a new browser tab.</span></li>
                        <li class="onlineDocumentFeatures"><div class="icon icon-access_rights"></div> <b>Share</b> - (available in the <em>online version</em> only) allows <a href="../HelpfulHints/CollaborativeEditing.htm" onclick="onhyperlinkclick(this)">setting access rights</a> for the documents stored in the cloud.</li>
                        <li><div class="icon icon-favorites_icon"></div> <b>Mark as favorite</b> - click the star to add a file to favorites as to make it easy to find. The added file is just a shortcut so the file itself remains stored in its original location. Deleting a file from favorites does not remove the file from its original location.</li>
                        <li><div class="icon icon-search_icon_header"></div> <b>Search</b> - allows to search the spreadsheet for a particular word or symbol, etc.</li>
                    </ul>
                </li>                
                <li>The <b>top toolbar</b> displays a set of editing commands depending on the selected menu tab. Currently, the following tabs are available: <a href="../ProgramInterface/FileTab.htm" onclick="onhyperlinkclick(this)">File</a>, <a href="../ProgramInterface/HomeTab.htm" onclick="onhyperlinkclick(this)">Home</a>, <a href="../ProgramInterface/InsertTab.htm" onclick="onhyperlinkclick(this)">Insert</a>, <a href="../ProgramInterface/DrawTab.htm" onclick="onhyperlinkclick(this)">Draw</a>, <a href="../ProgramInterface/LayoutTab.htm" onclick="onhyperlinkclick(this)">Layout</a>, <a href="../ProgramInterface/FormulaTab.htm" onclick="onhyperlinkclick(this)">Formula</a>, <a href="../ProgramInterface/DataTab.htm" onclick="onhyperlinkclick(this)">Data</a>, <span class="onlineDocumentFeatures"><a href="../ProgramInterface/PivotTableTab.htm" onclick="onhyperlinkclick(this)">Pivot Table</a>,</span> <a href="../ProgramInterface/CollaborationTab.htm" onclick="onhyperlinkclick(this)">Collaboration</a>, <a href="../ProgramInterface/ProtectionTab.htm" onclick="onhyperlinkclick(this)">Protection</a>, <a href="../ProgramInterface/ViewTab.htm" onclick="onhyperlinkclick(this)">View</a>, <a href="../ProgramInterface/PluginsTab.htm" onclick="onhyperlinkclick(this)">Plugins</a>.
                    <p>The <span class = "icon icon-copy"></span> <b>Copy</b>, <span class = "icon icon-paste"></span> <b>Paste</b>, <span class="icon icon-cut"></span> <b>Cut</b> and <span class="icon icon-select_all"></span> <b>Select All</b> options are always available at the left part of the <b>Top toolbar</b> regardless of the selected tab.</p>
                </li>
                <li>The <b>Formula bar</b> allows entering and editing <a href="../UsageInstructions/InsertFunction.htm" onclick="onhyperlinkclick(this)">formulas</a> or values in the cells. The <b>Formula bar</b> displays the contents of the currently selected cell.</li>
                <li>The <b>Status bar</b> at the bottom of the editor window contains some <a href="../HelpfulHints/Navigation.htm" onclick="onhyperlinkclick(this)">navigation tools</a>: sheet navigation buttons, add worksheet button, list of sheets button, sheet tabs, and zoom buttons. The <b>Status bar</b> also displays the background save status and connection status when there is no connection and the editor is trying to reconnect, the number of filtered records if you apply a <a href="../UsageInstructions/SortData.htm#filter" onclick="onhyperlinkclick(this)">filter</a>, or the results of <a href="../UsageInstructions/InsertFunction.htm" onclick="onhyperlinkclick(this)">automatic calculations</a> if you select several cells containing data.</li>
                <li>
                    <b>The Left sidebar</b> contains the following icons:
                    <ul>
                        <li><div class = "icon icon-searchicon"></div> - allows using the <a href="../HelpfulHints/Search.htm" onclick="onhyperlinkclick(this)">Search and Replace</a> tool,</li>
                        <li><div class = "icon icon-commentsicon"></div> - allows opening the <a href="../HelpfulHints/CollaborativeEditing.htm#comments" onclick="onhyperlinkclick(this)">Comments</a> panel,</li>
                        <li class="onlineDocumentFeatures"><div class = "icon icon-chaticon"></div> - (available in the <em>online version</em> only) allows opening the <a href="../HelpfulHints/CollaborativeEditing.htm#chat" onclick="onhyperlinkclick(this)">Chat</a> panel,</li>
                        <li><div class = "icon icon-spellcheckdeactivated"></div> - allows to check the spelling of your text in a certain language and correct mistakes while editing.</li>
                        <li class="onlineDocumentFeatures"><div class = "icon icon-feedbackicon"></div> - allows contacting our support team,</li>
                        <li class="onlineDocumentFeatures"><div class = "icon icon-about"></div> - (available in the <em>online version</em> only) allows viewing the information about the program.</li>
                    </ul>
                </li>
                <li>The <b>Right sidebar</b> allows adjusting additional parameters of different objects. When you select a particular object in a worksheet, the corresponding icon is activated on the right sidebar. Click this icon to expand the right sidebar.</li>
                <li>The <b>Working area</b> allows viewing the contents of a spreadsheet, as well as entering and editing data.</li>
                <li>The horizontal and vertical <b>Scroll bars</b> allow scrolling up/down and left/right.</li>
            </ol>
            <p>For your convenience, you can hide some components and display them again when necessary. To learn more on how to adjust view settings please refer to <a href="../HelpfulHints/Navigation.htm" onclick="onhyperlinkclick(this)">this page</a>.</p>
            <p>When there are many icons on the left and right panels, the ones below will be hidden, and they can be accessed via the <b>More</b> button.</p>
		</div>
	</body>
</html>